﻿/*
#------------------------------------------------------------------------------
#-- Program Name:	[dbo].[spDBA_update_server_inerror]
#-- Purpose:		Updates the server record with an error status
#--	Last Update:	08/23/2011
#--					For a complete history - please review comments in Version
#--					Control.
#------------------------------------------------------------------------------
*/
CREATE PROCEDURE [dbo].[spDBA_update_server_inerror]
(
	@server_name		varchar(60)
)
AS

SET NOCOUNT ON

UPDATE	dbo.tblServer
SET		srv_last_error = GETDATE()
WHERE	srv_server_name = @server_name

SET NOCOUNT OFF